Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Manually adding PROGRESS_RECID to ORACLE

If you have an existing ORACLE database, and you wish to take advantage of FIND PREV/LAST statements and cursor repositioning in an OpenEdge application for this database, you must manually add the PROGRESS_RECID.

To manually add PROGRESS_RECID to the ORACLE database:

Using SQL*Plus, log in as the ORACLE user who owns the table.
Create a sequence generator for the table named table-name_SEQ. Start with 1 and increment by 1, as shown:

CREATE SEQUENCE table-name_SEQ START WITH 1 INCREMENT BY 1;

Add a column to the table named progress_recid. This column holds a number that can be null. For example:

ALTER TABLE table-name ADD (progress_recid number null);

Update the table and set the progress_recid using table-name_SEQ.nextval, as shown:

UPDATE table-name SET progress_recid = table-name_SEQ.nextval;

Create a unique index name, table-name##progress_recid, that consists of just the progress_recid column, as shown:

CREATE UNIQUE INDEX table-name##progress_recid ON table-name (progress_recid);

Drop every non-unique index from the table and recreate it using the same components. Add progress_recid as the last component, as shown:

DROP INDEX table-name##index-name; CREATE INDEX table-name##index-name ON table-name (column-name, progress_recid);

Verify that the sequence was created. For example:

SELECT table-name_SEQ FROM sys.dual;

Connect to ORACLE and use the OpenEdge Data Dictionary’s ORACLE utilities to update the schema holder.